package com.zy.web.domain;

import com.zy.common.core.domain.BaseEntity;
import lombok.Data;
import org.hibernate.annotations.Comment;
import org.hibernate.annotations.SQLDelete;
import org.hibernate.annotations.Where;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Table;
import java.time.LocalDateTime;

@Data
@Entity
@Table(name = "zy_competition")
@org.hibernate.annotations.Table(appliesTo = "zy_competition", comment = "竞赛项目表")
@Where(clause = "deleted is null or deleted != true")
@SQLDelete(sql = "update zy_competition set deleted = true where id = ? ")
public class ZyCompetition extends BaseEntity {

    /**
     * 时间sj
     */
    @Comment("时间sj")
    @Column(name = "sj")
    private LocalDateTime sj;

    /**
     * 地点dd
     */
    @Comment("地点dd")
    @Column(name = "dd")
    private String dd;

    /**
     * 项目名称xmmc
     */
    @Comment("项目名称xmmc")
    @Column(name = "xmmc")
    private String xmmc;

    /**
     * 项目类型xmlx
     */
    @Comment("项目类型xmlx")
    @Column(name = "xmlx")
    private String xmlx;

    /**
     * 最大人数/队伍数zdrs
     */
    @Comment("最大人数/队伍数zdrs")
    @Column(name = "zdrs")
    private int zdrs;

    /**
     * 人员要求ryyq
     */
    @Comment("人员要求ryyq")
    @Column(name = "ryyq")
    private String ryyq;

    /**
     * 裁判人数cprs
     */
    @Comment("裁判人数cprs")
    @Column(name = "cprs")
    private int cprs;

    /**
     * 裁判 cp
     */
    @Comment("裁判 cp")
    @Column(name = "cp")
    private String cp;

    /**
     * 志愿者人数zyzrs
     */
    @Comment("志愿者人数zyzrs")
    @Column(name = "zyzrs")
    private int zyzrs;

    /**
     * 志愿者zyz
     */
    @Comment("志愿者zyz")
    @Column(name = "zyz")
    private String zyz;

    /**
     * 物资wz
     */
    @Comment("物资wz")
    @Column(name = "wz")
    private String wz;

    /**
     * 参赛者csz(项目的参赛成员，成员名用逗号隔开)
     */
    @Comment("参赛者csz")
    @Column(name = "csz")
    private String csz;

    /**
     * 用户名 yhm
     */
    @Comment("用户名 yhm")
    @Column(name = "yhm")
    private String yhm;

}
